Help Table of Contents
Client Help
- Pro Client
- Pro Workflow Overview
- Pro Client Workspace
- Content Management
- Accessing Content
- Content Manager
- Content Actions and Tools
- Maintenance Mode
- Presentation Launcher
- Copy-Paste
- Cut-Paste or Move
- Delete, Purge and Restore
- Run Slide Show
- Print Folder
- Change Description
- Import and Export
- Lineage
- Open Related Content
- Action Panel
- Metadata Panel
- Content Tagging
- Content Versioning
- Copy URL Link
- OData Feed
- Embed Snippet Generator
- Audit Trail (CMS)
- Content Roles Panel
- Data Source Changer
- Structure Analyzer
- Scheduling and Subscriptions
- Alerts Manager
- Migration Wizard
- Materialized Data Manager
- Schedule and Subscription Manager
- Pro Apps
- Model
- Data Modeling Concepts
- Smart Modeling
- Model Lite
- Direct Model
- Model Pro
- Model Pro Examples
- Master Flow
- Data Flow
- Data Flow Interface
- Sources
- Data Flow Targets
- Select
- Preparation
- Column Operations
- Joins
- Machine Learning
- Scripting
- Model Transfer Cleanup
- Data Modeling
- Model Processing
- Security
- Model Management
- Discover
- Viewing Discover Content
- Natural Language Query
- Smart Discover
- Discover Lite
- Discover Pro
- Access Discover Pro
- Discover Pro Workspace
- Navigating and Querying Data
- Building Queries
- Using Data Model Metadata
- Drop Zones
- Values Drop Zone
- Column and Row Drop Zone
- Categories Drop Zone
- Trellis Drop Zones
- Color Drop Zone
- Shape Drop Zone
- Size Drop Zone
- Labels Drop Zone
- Tooltip Drop Zone
- Indicator and Status Drop Zones
- Motion Drop Zone
- Details Drop Zone
- Map Location/ Shape Drop Zone
- Filter Drop Zone
- More Drop Zone Options
- Building Visualizations
- Running Queries
- Changing and Manipulating Queries
- Calculations in Discover
- Query Options
- Building Queries
- Formatting and Design
- Report Design
- Visualization Design
- Extended Functionality
- Manage Discoveries
- Auto Discover
- Formulate
- Present
- Smart Present
- Present Lite
- Presentation Overview
- Presentation Design
- Presentation Analytics
- Presentation Runtime
- Publish
- Illustrate
- Model
- Viewer Client
- Mobile Devices
Admin Help
- Summary Panel
- Licensing
- Access
- Data
- Content
- Services
- Schedules
- Logging
- Mobile Devices
- Design
- Geospatial
- AI and ML
Guides
- Installation Guides
- Main Application
- System Requirements
- Quick Guide for Windows
- Quick Guide for Linux
- Upgrade Installations
- Unattended Installations
- Installation Steps
- Repository Backups
- Kubernetes
- Pulse
- Client Desktop
- System Maintenance Tools
- Uninstallation
- Main Application
- Pyramid Licensing
- Cloud Server Quick Start
- Deploying Pyramid to AWS Kubernetes
- Scaling Pyramid
- User Deployment in Pyramid
- Application Security Overview
- Model and Analyze Pyramid Usage
- Kerberos Delegation for Pyramid
- Mobile App Deployment
- SAP SSO 'SNC' Setup Guide
- Support for SAP BW Features
- Troubleshooting Guide for SAP BW
- Amazon Load Balancer
- BI Office Content Conversion
- Other Pyramid Help Resources
- Version History
- Older Versions of Help
Tech Reference
- Query & Function Overview
- PQL & MDX Language Reference
- MDX Language
- Semantic Library (MDX)
- Date-Time Functions
- Hierarchical Functions
- Ascendants
- Children
- Cousin
- Descendants
- Dimension
- Dimensions
- DrilldownLevel
- DrilldownLevelBottom
- DrilldownLevelTop
- DrilldownMember
- DrilldownMemberBottom
- DrilldownMemberTop
- DrillupLevel
- DrillupMember
- FirstChild
- FirstSibling
- Hierarchy
- LastChild
- LastSibling
- Level
- Levels
- Ordinal
- Parent
- RollupChildren
- Root
- Siblings
- KPI Functions
- List Functions
- AddCalculatedMembers
- AllMembers
- Ancestors
- Axis
- BottomCount
- BottomPercent
- BottomSum
- Crossjoin
- Distinct
- Except
- Exists
- Extract
- Filter
- Generate
- Head
- Hierarchize
- Intersect
- Leaves
- MeasureGroupMeasures
- Members
- NameToSet
- NonEmpty
- NonEmptyCrossjoin
- Order
- StripCalculatedMembers
- Subset
- Tail
- ToggleDrillState
- TopCount
- TopPercent
- TopSum
- Union
- Unorder
- Logical Functions
- Member Functions
- Other Functions
- Statistical Functions
- String Functions
- VBA Library (MDX)
- Semantic Library (MDX)
- PQL Language
- undefined
- Common Library (PQL)
- Date-Time Functions
- Formats Functions
- CurrencyDollars0
- CurrencyDollars2
- CurrencyEuros0
- CurrencyEuros2
- CurrencyPounds0
- CurrencyPounds2
- CurrencyRands0
- CurrencyRands2
- CurrencyShekels0
- CurrencyShekels2
- CurrencySwissFrancs0
- CurrencySwissFrancs2
- DateAmerican
- DateTimeAmerican
- DateTimeUniversal
- DateTimeWestern
- DateUniversal
- DateWestern
- Number0
- Number1
- Number2
- NumberBillions
- NumberMillions
- NumberThousands
- Percent0
- Percent1
- Percent2
- Geo Functions
- Identity Functions
- Logical Functions
- Math Functions
- Statistical Functions
- String Functions
- Dynamic Library (PQL)
- Granular Library (PQL)
- Semantic Library (PQL)
- Context Library (PQL)
- Function Elements and Syntax
- Script Editors
- MDX Language
- PQL & MDX Language Reference
- Extensibility
- APIs
- REST API's
- REST API HTTP Status Codes
- Authentication APIs Overview
- API 2.0 Methods
- Access APIs
- addDomainSettings
- addProfile
- addUserToRole
- addUsersToRole
- changeLicenseForUser
- changeRoleAdGroupMembership
- createRole
- createRoles
- createTenant
- createTenants
- createUserAd
- createUserDb
- createUserOpenId
- createUserSaml
- createUsersAd
- createUsersDb
- createUsersOpenId
- createUsersSaml
- deleteProfile
- deleteRole
- deleteTenants
- deleteUser
- getAllNonPrivateRoles
- getAllNonPrivateRolesByTenant
- getAllNonPrivateRolesIDByTenant
- getAllProfiles
- getAllProfilesByTenantId
- getAllRoles
- getAllRolesByProfileId
- getAllRolesByUser
- getAllTenants
- getAllUsersByCurrentTenant
- getAllUsersByTenant
- getAllUsersDataByTenantAndLicenceType
- getAvailableTenantLicenseCount
- getDefaultTenant
- getGroupsByRole
- getLicenseCount
- getLicenseExpirationDate
- getLicenseValidationStatus
- getMe
- getPrivateProfileIdForUser
- getRoleById
- getRolesByName
- getTenantByName
- getUser
- getUserByOpenIdPrincipalName
- getUserBySamlPrincipalName
- getUserLastLogin
- getUserStatusById
- getUserStatusByName
- getUsersByName
- getUsersByRole
- searchAdGroups
- searchAdGroupsForUser
- searchAdUsers
- searchAdUsersForGroups
- setUserAdministrationLevel
- toggleEnableUser
- updateRolesByProfileId
- updateTenantSeats
- updateUserAd
- updateUserDb
- updateUserOpenId
- updateUserRoles
- updateUserSaml
- updateUsersAd
- updateUsersDb
- updateUsersOpenId
- updateUsersPhones
- updateUsersSaml
- Auth APIs
- Content APIs
- addContentItemsToFavorites
- addRoleToItem
- addTag
- addTagToItem
- changeItemDescription
- changeItemFolder
- copyItems
- createNewFolder
- deleteTag
- exportContent
- findContentItem
- findItemsByTagId
- findItemsByTagName
- getAllItemTags
- getAllItemsCreatedByUser
- getAllTags
- getAllUserContentItems
- getAutoRecommendedItems
- getContentItemMetaData
- getContentItemSecurityRoles
- getContentItemSecurityRolesID
- getFavoriteItems
- getFolderChildrenOnlyFolders
- getFolderItems
- getMostUsedItems
- getPrivateFolderForUser
- getPrivateRootFolder
- getPublicOrGroupFolderByTenantId
- getRecentItems
- getRecommendedItems
- getTag
- getUserGroupFolders
- getUserGroupRootFolder
- getUserPrivateFolder
- getUserPrivateRootFolder
- getUserPublicFolders
- getUserPublicRootFolder
- importContent
- moveItems
- purgeContentItems
- removeContentItemsFromFavorites
- removeRolesFromItem
- removeTagFromItem
- renameItem
- restoreSoftDeletedContentItems
- softDeleteContentItems
- Datasources APIs
- addHierarchySecurityToModel
- addMeasureSecurityToModel
- addMembersSecurityToModel
- addRolesToDataBase
- addRolesToItemAndBubbleUp
- addRolesToItemAndPropagate
- addRolesToModel
- addRolesToServer
- changeDataSource
- createDataServer
- createDataServers
- deleteDataBase
- deleteDataSource
- deleteMaterializedModel
- deleteRolesFromDatabase
- deleteRolesFromModel
- deleteRolesFromServer
- executeMasterFlow
- exportModel
- findDatabaseByName
- findModelByName
- findServerByName
- getAllConnectionStrings
- getDataModelStructure
- getDataSourcesByTenant
- getDataSourcesByUserId
- getItemConnectionString
- getMasterFlowProgressUpdate
- getMasterFlowVariables
- getRolesByDataBase
- getRolesByModel
- getRolesByServer
- getServerDataById
- getSourceByNodeId
- getTargetByNodeId
- importModel
- recognizeDataBase
- recognizeModel
- updateSourceNodeConnection
- updateTargetNodeConnection
- updateVariableConnection
- updateVariableValue
- validateMasterFlow
- Notification APIs
- Query APIs
- Tasks APIs
- Themes APIs
- Access APIs
- API 1.0 Methods
- Admin APIs
- addActiveDirectoryUser
- addFolderToDefaultTenant
- addRolesToItem
- addServerRoles
- addUserToRole
- changeLicenseForUser
- changeUserAdminType
- createRole
- createRoles
- createTenants
- createTheme
- createUser
- createUsers
- deleteMaterializedModel
- deleteRole
- deleteTenant
- deleteTheme
- deleteUser
- duplicateTheme
- exportTheme
- exportThemeById
- getAllItemsByUser
- getAllNonPrivateRoles
- getAllNonPrivateRolesByTenant
- getAllPrivateRolesByTenant
- getAllRoles
- getAllRolesByUser
- getAllTenants
- getAllUsersByCurrentTenant
- getAvailiableTenantLicenseCount
- getConnectionStringId
- getDataSourceForUser
- getDefaultTenant
- getExecutions
- getGroupsByRole
- getLicenseCount
- getLicenseExpirationDate
- getLicenseValidationStatus
- getMaterializedRoles
- getRole
- getRolesByName
- getRolesForItem
- getServerByName
- getTenantByName
- getUser
- getUserLastLogin
- getUserList
- getUserStatus
- getUsersByName
- getUsersByRole
- getVersion
- importTheme
- searchAdGroups
- searchAdGroupsForUser
- searchAdUsers
- searchAdUsersForGroup
- setDefaultTheme
- setItemAsFavorite
- testDataSourceStatus
- toggleEnableUser
- updateUser
- updateUserRoles
- Auth APIs
- Operations APIs
- addTag
- addTagToItem
- addTask
- changeDataSourceForSpecificConnectionString
- changeDataSources
- changeFolderParentFolder
- changeItemDescription
- changeItemFolder
- copyItems
- createDataSource
- createDataSources
- createNewFolder
- dataSourceChanger
- deleteDataSource
- deleteTask
- deployModelFromPie
- exportPie
- getAllTags
- getContentItemsByFolder
- getDefaultTheme
- getFeedsCount
- getItemMetaData
- getItemsByDataSource
- getRecentItems
- getScheduleExecutionStatus
- getSchedulesForUser
- getThemes
- importAndDscPie
- importPie
- moveItems
- purgeItem
- removeTagFromItem
- renameItem
- resumeTask
- runSchedule
- searchContent
- softDeleteItem
- suspendTask
- Query APIs
- Admin APIs
- API Objects and Enumerations
- API Object Definitions
- AdUserData
- AddUsersRoleData
- AdditionalServerProperties
- AdminMultiTenantData
- AdminTypeApiData
- ChangeItemDescriptionData
- ChangeUserLicenseData
- ChangeUserLicenseObject
- ConnStringDscApiObject
- ConnectedItemsSearchCriteria
- ConnectionStringProperties
- ContentSearchParamsObject
- CreateUserAdObject
- CreateUserDbObject
- CreateUserOpenIdObject
- CreateUserSamlObject
- DataBaseRecognitionObject
- DeleteTenantApiData
- DomainSecurityObject
- DscApiData
- ExecuteMasterFlowObject
- ExecuteMasterFlowResult
- ExecuteScheduleApiData
- ExecutionViewData
- ExportData
- ExportOptions
- ExternalParameters
- FilterParameter
- FolderTenantObject
- HierarchyMeasureSecurityApiObject
- ImportApiResultObject
- ItemId
- ItemParentApiData
- ItemRolePair
- ItemRolesForRemoval
- ItemRolesToBeAdded
- ItemsForFavorites
- LdapGroupDetails
- LdapGroupIdentifier
- LdapSearchObject
- LdapUserObject
- LdapUsersSearchObject
- MasterFlowFindDataSourceObject
- MasterFlowOtherObject
- MasterFlowProgressResult
- MasterFlowSourceConnectionObject
- MasterFlowSourceObject
- MasterFlowTargetConnectionObject
- MasterFlowTargetObject
- MasterFlowUpdatedVariableResult
- MasterFlowValidationResult
- MasterFlowVariableConnectionObject
- MasterFlowVariableObject
- MasterFlowVariableValueObject
- MasterFlowVariablesResult
- MasterFlowVariablesValueObject
- MaterializedApiObject
- MaterializedItemObject
- MeasureGroup
- MembersSecurityApiObject
- ModelDataFlowSourceInfo
- ModelRecognitionObject
- ModelingColumn
- ModelingHierarchy
- ModelingHierarchyLevel
- ModelingMeasure
- ModelingModel
- ModelingProperty
- ModelingRelationship
- ModelingRelationshipColumnPair
- ModelingTable
- ModifiedItemsResult
- MoveItemsObject
- NewFolderApiData
- NewTenantObject
- NotificationIndicatorsResult
- PieApiObject
- ProfileApiData
- ProfilePermissionHolder
- ProfileRolesData
- PyramidContentItem
- PyramidItemIdentifier
- PyramidViewUserObject
- QueryExportData
- RenameItemApiData
- ResultsObjectData
- RoleAdGroupsModifyObject
- RoleData
- RoleMinimalData
- RoleToItemApiData
- RolesInItemRemovalObject
- ScheduleSearchCriteria
- ScheduleViewObject
- SearchAdGroupUsersData
- SearchAdUserGroupsData
- SearchCriteria
- ServerData
- TagData
- TagUsageApiData
- TargetParameter
- TaskUserApiData
- TaskViewData
- TenantLicenseTypeData
- TenantSettings
- TenantUsersGetObject
- ThemeApiData
- ThemeApiObject
- ThemeListObject
- ToggleUserApiData
- UpdateTenantSeatsObject
- UpdateUserAdObject
- UpdateUserDbObject
- UpdateUserOpenIdObject
- UpdateUserSamlObject
- UserCredentials
- UserData
- UserOpenIdCredentials
- UserRolesData
- UserSamlCredentials
- UserTokenCredentials
- API Enumeration Definitions
- AccessType
- AdjunctRequestType
- AdminType
- AggregationType
- AlertIndicatorType
- ApiResponseFormat
- AssetType
- AxisTotalsType
- AxisType
- CacheMode
- CalcCategoryType
- CalcType
- CartesianType
- ChipCategory
- ClientLicenseType
- CmsNodeExtraDataType
- CollaborationOpenOptions
- CollaborationRequestType
- ColoringDirection
- ColumnPropertiesType
- ComponentType
- ConditionConjunctionType
- ConditionFormulaType
- ConnectionStringType
- ContainerType
- ContentItemObject
- ContentType
- ContentTypeObject
- ConversationType
- CubeAuthMethod
- CustomFontContentType
- CustomSetDiscreteValueType
- CustomVisualApiVersion
- DataFlowModelType
- DataPattern
- DateSearchType
- DateSelectionType
- DayType
- DeviceType
- DiscoveryWorkspaceType
- DocumentTypeEnum
- DrillState
- DropZoneType
- DynamicEntityType
- ElementFunctionType
- EtlExecutionContextType
- EvaluationSetFunctionType
- ExcelRenderingType
- ExecutionArea
- FunctionArgumentType
- GeneralExecutionError
- HideMemberType
- HideShowOption
- HierarchyCategory
- HierarchyType
- ImageSize
- ImageUploadStatus
- InteractionContainerType
- InteractionType
- ItemType
- JoinType
- KpiAttributeType
- KpiStylesOptions
- LayoutBehaviorType
- LayoutElementContentType
- LayoutElementLegendPosition
- LdapSearchType
- LicenseStatus
- MasterPageType
- MaterializedItemType
- MaterializedRoleAssignmentType
- MathFunction
- MessagesDisplayType
- MiniatureMode
- MobileApplicationType
- MobileDeviceType
- ModelAttributeType
- ModelParameterOperator
- ModelTextOption
- ModelingColumnCategories
- ModelingParameterSelectionType
- ModelingTableType
- MonthDayType
- NaturalOrderType
- OnPeakDayOfWeek
- OperatorType
- OsType
- PDFConverterType
- PanelPosition
- PanelSubTitleType
- PanelTitleType
- PaperType
- ParentChildOrphanHandlingType
- ParentChildRollupType
- PermissionBitIndex
- PredefinedItemSaveType
- PrintingHeaderFooterSectionPosition
- PrintingHeaderFooterType
- PrintingImageQuality
- PrintingJobType
- PrintingOnlineJobType
- PrintingOutputType
- PrintingPagingType
- PrintingType
- PromDefaultSelectionType
- PromSelectionType
- PropertyFieldType
- PyramidActionParentContainerType
- PyramidActionTargetType
- PyramidActionType
- QomAxisFilterCalculationType
- QomAxisOrderType
- QomSelectionType
- QueryInputSelectionType
- QueryLanguageState
- QueryResultMessageExtraData
- QueryScope
- RatingSearchType
- RecurringType
- ReductionType
- RequestOrigin
- RoleAssignmentType
- RootFolderType
- RotationDirection
- ScaleMode
- ScheduleDataType
- ScheduleResultType
- ScheduleStatus
- ScheduleType
- ScheduleViewType
- ScriptType
- SearchMatchType
- SearchRootFolderType
- SectionType
- SecurityType
- SelectionMethod
- ServerAuthenticationMethod
- SimpleAdvancedOptions
- SlicerMemberDataType
- SlicerSearchType
- SlicerSelectionMode
- SyntaxType
- TabAppearanceType
- TabPosition
- TagType
- TaskStatus
- TextFieldType
- ThemeType
- ThreadType
- UserStatusID
- ValidRootFolderType
- API Object Definitions
- Custom Visual API
- Custom WorkFlow API
- REST API's
Pyramid Analytics © 2017-2022